﻿--Truy van 01
SELECT MABN, CMND,DienThoai, HoTen, NgaySinh, DiaChi, GioiTinh
FROM BENHNHAN WHERE CMND = 'S5DBDN1W3N95M7SGZ0THQYQ5HDUL'
--Truy van 02
USE [BenhVien_Team_30]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[sp_ThemMoiHoSoBenhNhan]
		@CMND = NULL,
		@DienThoai = NULL,
		@HoTen = NULL,
		@NgaySinh = NULL,
		@DiaChi = NULL,
		@GioiTinh = NULL,
		@SoThe = NULL,
		@NgayHetHang = NULL,
		@TinhTrang = NULL

SELECT	'Return Value' = @return_value

GO
--Truy van 03:
USE [BenhVien_Team_30]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[sp_ThemMoiHoSoBenhAn]
		@XetNghiem = NULL,
		@ChuanDoan = NULL,
		@ChiDinh = NULL,
		@MaBN = NULL,
		@HoTen = NULL,
		@CMND = NULL,
		@TinhTrangBenh = NULL,
		@SoPhong = NULL,
		@NgayKham = NULL

SELECT	'Return Value' = @return_value

GO
--Truy van 04:
USE [BenhVien_Team_30]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[sp_TieuSuBenh]
		@MaHS = 123

SELECT	'Return Value' = @return_value

GO
--Truy van 05:
USE [BenhVien_Team_30]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[sp_ThemMoiHoSoNhapVien]
		@CMND = NULL,
		@DienThoai = NULL,
		@HoTen = NULL,
		@NgaySinh = NULL,
		@DiaChi = NULL,
		@GioiTinh = NULL,
		@SoPhong = NULL,
		@MaBS = NULL,
		@SoThe = NULL,
		@NgayHetHang = NULL,
		@XetNghiem = NULL,
		@ChuanDoan = NULL,
		@ChiDinh = NULL,
		@TinhTrangBenh = NULL,
		@TinhTrang = NULL

SELECT	'Return Value' = @return_value

GO
